Data Profiling Report After Initial Cleaning

Dataset statistics

Number of variables	28
Number of observations	1723626
Missing cells	230662
Missing cells (%)	0.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	266.3 MiB
Average record size in memory	162.0 B

Variable types

Categorical	10
Numeric	16
Text	1
DateTime	1

Alerts

`addr_state` has a high cardinality: 51 distinct values	High cardinality
`application_type` is highly imbalanced (76.8%)	Imbalance
`emp_length` has 109140 (6.3%) missing values	Missing
`emp_title` has 121522 (7.1%) missing values	Missing
`annual_inc` is highly skewed (γ1 = 517.5385092)	Skewed
`dti` is highly skewed (γ1 = 29.57193785)	Skewed
`bc_util` has 22674 (1.3%) zeros	Zeros
`chargeoff_within_12_mths` has 1709623 (99.2%) zeros	Zeros
`delinq_2yrs` has 1393559 (80.9%) zeros	Zeros
`inq_last_6mths` has 1022454 (59.3%) zeros	Zeros
`last_fico_range_low` has 46252 (2.7%) zeros	Zeros

Reproduction

Analysis started	2024-07-08 02:51:42.921747
Analysis finished	2024-07-08 02:52:18.370852
Duration	35.45 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

addr_state
Categorical

HIGH CARDINALITY

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

CA	243479
TX	142374
NY	139295
FL	123796
IL	67521
Other values (46)	1007161

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3447252
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	NC
2nd row	TX
3rd row	MI
4th row	TX
5th row	NC

Common Values

Value	Count	Frequency (%)
CA	243479	14.1%
TX	142374	8.3%
NY	139295	8.1%
FL	123796	7.2%
IL	67521	3.9%
NJ	61865	3.6%
PA	57868	3.4%
OH	56692	3.3%
GA	56194	3.3%
NC	48316	2.8%
Other values (41)	726226	42.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	243479	14.1%
tx	142374	8.3%
ny	139295	8.1%
fl	123796	7.2%
il	67521	3.9%
nj	61865	3.6%
pa	57868	3.4%
oh	56692	3.3%
ga	56194	3.3%
nc	48316	2.8%
Other values (41)	726226	42.1%

Most occurring characters

Value	Count	Frequency (%)
A	580883	16.9%
N	389300	11.3%
C	380244	11.0%
L	231861	6.7%
T	216961	6.3%
M	210067	6.1%
I	184275	5.3%
Y	159593	4.6%
O	158406	4.6%
X	142374	4.1%
Other values (14)	793288	23.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3447252	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	580883	16.9%
N	389300	11.3%
C	380244	11.0%
L	231861	6.7%
T	216961	6.3%
M	210067	6.1%
I	184275	5.3%
Y	159593	4.6%
O	158406	4.6%
X	142374	4.1%
Other values (14)	793288	23.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3447252	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	580883	16.9%
N	389300	11.3%
C	380244	11.0%
L	231861	6.7%
T	216961	6.3%
M	210067	6.1%
I	184275	5.3%
Y	159593	4.6%
O	158406	4.6%
X	142374	4.1%
Other values (14)	793288	23.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3447252	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	580883	16.9%
N	389300	11.3%
C	380244	11.0%
L	231861	6.7%
T	216961	6.3%
M	210067	6.1%
I	184275	5.3%
Y	159593	4.6%
O	158406	4.6%
X	142374	4.1%
Other values (14)	793288	23.0%

annual_inc
Real number (ℝ)

SKEWED

Distinct	74968
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77830.805

Minimum	0
Maximum	1.1 × 10⁸
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	28000
Q1	46500
median	65000
Q3	92700
95-th percentile	160000
Maximum	1.1 × 10⁸
Range	1.1 × 10⁸
Interquartile range (IQR)	46200

Descriptive statistics

Standard deviation	121155.26
Coefficient of variation (CV)	1.5566491
Kurtosis	430832.1
Mean	77830.805
Median Absolute Deviation (MAD)	21500
Skewness	517.53851
Sum	1.341512 × 10¹¹
Variance	1.4678596 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60000	66595	3.9%
50000	58612	3.4%
65000	50309	2.9%
70000	47848	2.8%
80000	45837	2.7%
40000	45448	2.6%
75000	44824	2.6%
45000	42113	2.4%
55000	40028	2.3%
100000	35834	2.1%
Other values (74958)	1246178	72.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
20	2	< 0.1%
23	1	< 0.1%
25	1	< 0.1%
32	1	< 0.1%
33	1	< 0.1%
39	1	< 0.1%
40	1	< 0.1%

Value	Count	Frequency (%)
110000000	1	< 0.1%
61000000	1	< 0.1%
10999200	1	< 0.1%
9573072	1	< 0.1%
9550000	1	< 0.1%
9522972	1	< 0.1%
9500000	1	< 0.1%
9300000	1	< 0.1%
9225000	1	< 0.1%
9100000	1	< 0.1%

application_type
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

Individual	1658410
Joint App	65216

Length

Max length	10
Median length	10
Mean length	9.9621635
Min length	9

Characters and Unicode

Total characters	17171044
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Individual
2nd row	Individual
3rd row	Individual
4th row	Individual
5th row	Individual

Common Values

Value	Count	Frequency (%)
Individual	1658410	96.2%
Joint App	65216	3.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
individual	1658410	92.7%
joint	65216	3.6%
app	65216	3.6%

Most occurring characters

Value	Count	Frequency (%)
i	3382036	19.7%
d	3316820	19.3%
n	1723626	10.0%
I	1658410	9.7%
v	1658410	9.7%
u	1658410	9.7%
a	1658410	9.7%
l	1658410	9.7%
p	130432	0.8%
J	65216	0.4%
Other values (4)	260864	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17171044	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	3382036	19.7%
d	3316820	19.3%
n	1723626	10.0%
I	1658410	9.7%
v	1658410	9.7%
u	1658410	9.7%
a	1658410	9.7%
l	1658410	9.7%
p	130432	0.8%
J	65216	0.4%
Other values (4)	260864	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17171044	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	3382036	19.7%
d	3316820	19.3%
n	1723626	10.0%
I	1658410	9.7%
v	1658410	9.7%
u	1658410	9.7%
a	1658410	9.7%
l	1658410	9.7%
p	130432	0.8%
J	65216	0.4%
Other values (4)	260864	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17171044	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	3382036	19.7%
d	3316820	19.3%
n	1723626	10.0%
I	1658410	9.7%
v	1658410	9.7%
u	1658410	9.7%
a	1658410	9.7%
l	1658410	9.7%
p	130432	0.8%
J	65216	0.4%
Other values (4)	260864	1.5%

avg_cur_bal
Real number (ℝ)

Distinct	82765
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13476.81

Minimum	0
Maximum	555925
Zeros	606
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	1080
Q1	3084
median	7368
Q3	18732.75
95-th percentile	43192
Maximum	555925
Range	555925
Interquartile range (IQR)	15648.75

Descriptive statistics

Standard deviation	16166.264
Coefficient of variation (CV)	1.1995616
Kurtosis	28.730209
Mean	13476.81
Median Absolute Deviation (MAD)	5391
Skewness	3.4866844
Sum	2.3228981 × 10¹⁰
Variance	2.6134809 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	606	< 0.1%
1971	224	< 0.1%
2253	222	< 0.1%
2606	216	< 0.1%
2842	216	< 0.1%
2149	215	< 0.1%
2289	213	< 0.1%
2301	213	< 0.1%
2335	212	< 0.1%
2656	212	< 0.1%
Other values (82755)	1721077	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	606	< 0.1%
1	52	< 0.1%
2	46	< 0.1%
3	50	< 0.1%
4	26	< 0.1%
5	42	< 0.1%
6	38	< 0.1%
7	29	< 0.1%
8	28	< 0.1%
9	31	< 0.1%

Value	Count	Frequency (%)
555925	1	< 0.1%
502002	1	< 0.1%
498284	1	< 0.1%
497484	1	< 0.1%
478909	1	< 0.1%
477255	1	< 0.1%
466840	1	< 0.1%
463945	1	< 0.1%
463276	1	< 0.1%
447102	1	< 0.1%

bc_util
Real number (ℝ)

ZEROS

Distinct	1473
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.153188

Minimum	0
Maximum	339.6
Zeros	22674
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	7.4
Q1	35.6
median	60.7
Q3	83.5
95-th percentile	97.9
Maximum	339.6
Range	339.6
Interquartile range (IQR)	47.9

Descriptive statistics

Standard deviation	28.722617
Coefficient of variation (CV)	0.49391302
Kurtosis	-0.99238278
Mean	58.153188
Median Absolute Deviation (MAD)	23.8
Skewness	-0.28610558
Sum	1.0023435 × 10⁸
Variance	824.98872
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22674	1.3%
98	4806	0.3%
97	4508	0.3%
99	4446	0.3%
96	4348	0.3%
95	4054	0.2%
94	3860	0.2%
93	3651	0.2%
92	3559	0.2%
91	3432	0.2%
Other values (1463)	1664288	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22674	1.3%
0.1	1873	0.1%
0.2	1650	0.1%
0.3	1385	0.1%
0.4	1211	0.1%
0.5	1155	0.1%
0.6	1059	0.1%
0.7	1037	0.1%
0.8	1004	0.1%
0.9	937	0.1%

Value	Count	Frequency (%)
339.6	1	< 0.1%
318.2	1	< 0.1%
255.2	1	< 0.1%
252.3	1	< 0.1%
243.8	1	< 0.1%
235.3	1	< 0.1%
204.6	1	< 0.1%
202.9	1	< 0.1%
202	1	< 0.1%
201.9	1	< 0.1%

chargeoff_within_12_mths
Real number (ℝ)

ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0091075442

Minimum	0
Maximum	10
Zeros	1709623
Zeros (%)	99.2%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.10979191
Coefficient of variation (CV)	12.055051
Kurtosis	615.20166
Mean	0.0091075442
Median Absolute Deviation (MAD)	0
Skewness	18.20006
Sum	15698
Variance	0.012054263
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	1709623	99.2%
1	12787	0.7%
2	951	0.1%
3	157	< 0.1%
4	61	< 0.1%
5	20	< 0.1%
6	12	< 0.1%
7	6	< 0.1%
9	6	< 0.1%
8	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1709623	99.2%
1	12787	0.7%
2	951	0.1%
3	157	< 0.1%
4	61	< 0.1%
5	20	< 0.1%
6	12	< 0.1%
7	6	< 0.1%
8	2	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
9	6	< 0.1%
8	2	< 0.1%
7	6	< 0.1%
6	12	< 0.1%
5	20	< 0.1%
4	61	< 0.1%
3	157	< 0.1%
2	951	0.1%
1	12787	0.7%

delinq_2yrs
Real number (ℝ)

ZEROS

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.31646715

Minimum	0
Maximum	39
Zeros	1393559
Zeros (%)	80.9%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	39
Range	39
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.88001455
Coefficient of variation (CV)	2.7807454
Kurtosis	60.074987
Mean	0.31646715
Median Absolute Deviation (MAD)	0
Skewness	5.6671897
Sum	545471
Variance	0.77442561
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	1393559	80.9%
1	219498	12.7%
2	63848	3.7%
3	23322	1.4%
4	10486	0.6%
5	5268	0.3%
6	3011	0.2%
7	1638	0.1%
8	1002	0.1%
9	629	< 0.1%
Other values (24)	1365	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1393559	80.9%
1	219498	12.7%
2	63848	3.7%
3	23322	1.4%
4	10486	0.6%
5	5268	0.3%
6	3011	0.2%
7	1638	0.1%
8	1002	0.1%
9	629	< 0.1%

Value	Count	Frequency (%)
39	1	< 0.1%
36	1	< 0.1%
32	1	< 0.1%
30	1	< 0.1%
29	2	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	3	< 0.1%
25	1	< 0.1%
24	1	< 0.1%

dti
Real number (ℝ)

SKEWED

Distinct	9209
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.739791

Minimum	-1
Maximum	999
Zeros	957
Zeros (%)	0.1%
Negative	2
Negative (%)	< 0.1%
Memory size	26.3 MiB

Quantile statistics

Minimum	-1
5-th percentile	5.06
Q1	11.96
median	17.87
Q3	24.51
95-th percentile	33.63
Maximum	999
Range	1000
Interquartile range (IQR)	12.55

Descriptive statistics

Standard deviation	13.159036
Coefficient of variation (CV)	0.70219757
Kurtosis	1933.1568
Mean	18.739791
Median Absolute Deviation (MAD)	6.24
Skewness	29.571938
Sum	32300391
Variance	173.16022
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.2	1234	0.1%
18	1224	0.1%
14.4	1210	0.1%
16.8	1203	0.1%
13.2	1154	0.1%
15.6	1154	0.1%
20.4	1121	0.1%
12	1103	0.1%
21.6	1076	0.1%
10.8	1029	0.1%
Other values (9199)	1712118	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	2	< 0.1%
0	957	0.1%
0.01	12	< 0.1%
0.02	23	< 0.1%
0.03	14	< 0.1%
0.04	9	< 0.1%
0.05	15	< 0.1%
0.06	25	< 0.1%
0.07	19	< 0.1%
0.08	21	< 0.1%

Value	Count	Frequency (%)
999	84	< 0.1%
994.4	1	< 0.1%
991.57	1	< 0.1%
962.83	1	< 0.1%
962.12	1	< 0.1%
942.17	1	< 0.1%
917.87	1	< 0.1%
893.1	1	< 0.1%
886.77	1	< 0.1%
879.55	1	< 0.1%

emp_length
Categorical

MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	109140
Missing (%)	6.3%
Memory size	14.8 MiB

10+ years	571557
2 years	155260
< 1 year	141144
3 years	137934
1 year	113352
Other values (6)	495239

Length

Max length	9
Median length	8
Mean length	7.72525
Min length	6

Characters and Unicode

Total characters	12472308
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4 years
2nd row	2 years
3rd row	10+ years
4th row	3 years
5th row	4 years

Common Values

Value	Count	Frequency (%)
10+ years	571557	33.2%
2 years	155260	9.0%
< 1 year	141144	8.2%
3 years	137934	8.0%
1 year	113352	6.6%
5 years	105963	6.1%
4 years	102600	6.0%
6 years	78203	4.5%
8 years	73749	4.3%
7 years	72300	4.2%
(Missing)	109140	6.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
years	1359990	40.4%
10	571557	17.0%
1	254496	7.6%
year	254496	7.6%
2	155260	4.6%
	141144	4.2%
3	137934	4.1%
5	105963	3.1%
4	102600	3.0%
6	78203	2.3%
Other values (3)	208473	6.2%

Most occurring characters

Value	Count	Frequency (%)
	1755630	14.1%
y	1614486	12.9%
e	1614486	12.9%
a	1614486	12.9%
r	1614486	12.9%
s	1359990	10.9%
1	826053	6.6%
0	571557	4.6%
+	571557	4.6%
2	155260	1.2%
Other values (8)	774317	6.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12472308	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1755630	14.1%
y	1614486	12.9%
e	1614486	12.9%
a	1614486	12.9%
r	1614486	12.9%
s	1359990	10.9%
1	826053	6.6%
0	571557	4.6%
+	571557	4.6%
2	155260	1.2%
Other values (8)	774317	6.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12472308	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1755630	14.1%
y	1614486	12.9%
e	1614486	12.9%
a	1614486	12.9%
r	1614486	12.9%
s	1359990	10.9%
1	826053	6.6%
0	571557	4.6%
+	571557	4.6%
2	155260	1.2%
Other values (8)	774317	6.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12472308	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1755630	14.1%
y	1614486	12.9%
e	1614486	12.9%
a	1614486	12.9%
r	1614486	12.9%
s	1359990	10.9%
1	826053	6.6%
0	571557	4.6%
+	571557	4.6%
2	155260	1.2%
Other values (8)	774317	6.2%

emp_title
Text

MISSING

Distinct	408249
Distinct (%)	25.5%
Missing	121522
Missing (%)	7.1%
Memory size	26.3 MiB

Length

Max length	42
Median length	32
Mean length	15.586813
Min length	1

Characters and Unicode

Total characters	24971695
Distinct characters	160
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	314396 ?
Unique (%)	19.6%

Sample

1st row	Project Manager
2nd row	Surgical Technician
3rd row	Team Leadern Customer Ops & Systems
4th row	Systems Engineer
5th row	Assistant Director - Human Resources

Value	Count	Frequency (%)
manager	239065	7.3%
director	61854	1.9%
sales	56831	1.7%
assistant	56386	1.7%
supervisor	45918	1.4%
specialist	43425	1.3%
teacher	43380	1.3%
engineer	41648	1.3%
senior	41454	1.3%
analyst	40728	1.3%
Other values (82815)	2584673	79.4%

Most occurring characters

Value	Count	Frequency (%)
e	2676869	10.7%
r	2151348	8.6%
a	1949747	7.8%
	1802391	7.2%
i	1724884	6.9%
n	1684663	6.7%
t	1542856	6.2%
o	1234681	4.9%
s	1215422	4.9%
c	1049633	4.2%
Other values (150)	7939201	31.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24971695	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	2676869	10.7%
r	2151348	8.6%
a	1949747	7.8%
	1802391	7.2%
i	1724884	6.9%
n	1684663	6.7%
t	1542856	6.2%
o	1234681	4.9%
s	1215422	4.9%
c	1049633	4.2%
Other values (150)	7939201	31.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24971695	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	2676869	10.7%
r	2151348	8.6%
a	1949747	7.8%
	1802391	7.2%
i	1724884	6.9%
n	1684663	6.7%
t	1542856	6.2%
o	1234681	4.9%
s	1215422	4.9%
c	1049633	4.2%
Other values (150)	7939201	31.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24971695	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	2676869	10.7%
r	2151348	8.6%
a	1949747	7.8%
	1802391	7.2%
i	1724884	6.9%
n	1684663	6.7%
t	1542856	6.2%
o	1234681	4.9%
s	1215422	4.9%
c	1049633	4.2%
Other values (150)	7939201	31.8%

fico_range_high
Real number (ℝ)

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	701.16961

Minimum	664
Maximum	850
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	664
5-th percentile	664
Q1	674
median	694
Q3	719
95-th percentile	769
Maximum	850
Range	186
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	32.469936
Coefficient of variation (CV)	0.046308247
Kurtosis	1.5546435
Mean	701.16961
Median Absolute Deviation (MAD)	20
Skewness	1.2606512
Sum	1.2085542 × 10⁹
Variance	1054.2967
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
664	150527	8.7%
674	145804	8.5%
669	145274	8.4%
684	130463	7.6%
679	130351	7.6%
689	114602	6.6%
694	111721	6.5%
699	100380	5.8%
704	93685	5.4%
709	85096	4.9%
Other values (28)	515723	29.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
664	150527	8.7%
669	145274	8.4%
674	145804	8.5%
679	130351	7.6%
684	130463	7.6%
689	114602	6.6%
694	111721	6.5%
699	100380	5.8%
704	93685	5.4%
709	85096	4.9%

Value	Count	Frequency (%)
850	294	< 0.1%
844	384	< 0.1%
839	598	< 0.1%
834	1039	0.1%
829	1552	0.1%
824	2072	0.1%
819	2828	0.2%
814	3354	0.2%
809	4694	0.3%
804	5511	0.3%

fico_range_low
Real number (ℝ)

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	697.16944

Minimum	660
Maximum	845
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	660
5-th percentile	660
Q1	670
median	690
Q3	715
95-th percentile	765
Maximum	845
Range	185
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	32.469156
Coefficient of variation (CV)	0.046572834
Kurtosis	1.5531038
Mean	697.16944
Median Absolute Deviation (MAD)	20
Skewness	1.2604289
Sum	1.2016594 × 10⁹
Variance	1054.2461
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
660	150527	8.7%
670	145804	8.5%
665	145274	8.4%
680	130463	7.6%
675	130351	7.6%
685	114602	6.6%
690	111721	6.5%
695	100380	5.8%
700	93685	5.4%
705	85096	4.9%
Other values (28)	515723	29.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
660	150527	8.7%
665	145274	8.4%
670	145804	8.5%
675	130351	7.6%
680	130463	7.6%
685	114602	6.6%
690	111721	6.5%
695	100380	5.8%
700	93685	5.4%
705	85096	4.9%

Value	Count	Frequency (%)
845	294	< 0.1%
840	384	< 0.1%
835	598	< 0.1%
830	1039	0.1%
825	1552	0.1%
820	2072	0.1%
815	2828	0.2%
810	3354	0.2%
805	4694	0.3%
800	5511	0.3%

grade
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

B	505036
C	491944
A	318334
D	257183
E	107703
Other values (2)	43426

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1723626
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B
2nd row	B
3rd row	B
4th row	A
5th row	B

Common Values

Value	Count	Frequency (%)
B	505036	29.3%
C	491944	28.5%
A	318334	18.5%
D	257183	14.9%
E	107703	6.2%
F	33821	2.0%
G	9605	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b	505036	29.3%
c	491944	28.5%
a	318334	18.5%
d	257183	14.9%
e	107703	6.2%
f	33821	2.0%
g	9605	0.6%

Most occurring characters

Value	Count	Frequency (%)
B	505036	29.3%
C	491944	28.5%
A	318334	18.5%
D	257183	14.9%
E	107703	6.2%
F	33821	2.0%
G	9605	0.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1723626	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	505036	29.3%
C	491944	28.5%
A	318334	18.5%
D	257183	14.9%
E	107703	6.2%
F	33821	2.0%
G	9605	0.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1723626	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	505036	29.3%
C	491944	28.5%
A	318334	18.5%
D	257183	14.9%
E	107703	6.2%
F	33821	2.0%
G	9605	0.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1723626	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	505036	29.3%
C	491944	28.5%
A	318334	18.5%
D	257183	14.9%
E	107703	6.2%
F	33821	2.0%
G	9605	0.6%

home_ownership
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

MORTGAGE	853277
RENT	676739
OWN	192344
ANY	1178
NONE	44

Length

Max length	8
Median length	5
Mean length	5.86794
Min length	3

Characters and Unicode

Total characters	10114134
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RENT
2nd row	MORTGAGE
3rd row	OWN
4th row	MORTGAGE
5th row	RENT

Common Values

Value	Count	Frequency (%)
MORTGAGE	853277	49.5%
RENT	676739	39.3%
OWN	192344	11.2%
ANY	1178	0.1%
NONE	44	< 0.1%
OTHER	44	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mortgage	853277	49.5%
rent	676739	39.3%
own	192344	11.2%
any	1178	0.1%
none	44	< 0.1%
other	44	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
G	1706554	16.9%
E	1530104	15.1%
R	1530060	15.1%
T	1530060	15.1%
O	1045709	10.3%
N	870349	8.6%
A	854455	8.4%
M	853277	8.4%
W	192344	1.9%
Y	1178	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10114134	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
G	1706554	16.9%
E	1530104	15.1%
R	1530060	15.1%
T	1530060	15.1%
O	1045709	10.3%
N	870349	8.6%
A	854455	8.4%
M	853277	8.4%
W	192344	1.9%
Y	1178	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10114134	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
G	1706554	16.9%
E	1530104	15.1%
R	1530060	15.1%
T	1530060	15.1%
O	1045709	10.3%
N	870349	8.6%
A	854455	8.4%
M	853277	8.4%
W	192344	1.9%
Y	1178	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10114134	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
G	1706554	16.9%
E	1530104	15.1%
R	1530060	15.1%
T	1530060	15.1%
O	1045709	10.3%
N	870349	8.6%
A	854455	8.4%
M	853277	8.4%
W	192344	1.9%
Y	1178	< 0.1%

inq_last_6mths
Real number (ℝ)

ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.60783836

Minimum	0
Maximum	8
Zeros	1022454
Zeros (%)	59.3%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	8
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.89797356
Coefficient of variation (CV)	1.477323
Kurtosis	3.5514995
Mean	0.60783836
Median Absolute Deviation (MAD)	0
Skewness	1.7561808
Sum	1047686
Variance	0.80635652
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	1022454	59.3%
1	461303	26.8%
2	161656	9.4%
3	56813	3.3%
4	15236	0.9%
5	5301	0.3%
6	859	< 0.1%
7	3	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1022454	59.3%
1	461303	26.8%
2	161656	9.4%
3	56813	3.3%
4	15236	0.9%
5	5301	0.3%
6	859	< 0.1%
7	3	< 0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
8	1	< 0.1%
7	3	< 0.1%
6	859	< 0.1%
5	5301	0.3%
4	15236	0.9%
3	56813	3.3%
2	161656	9.4%
1	461303	26.8%
0	1022454	59.3%

installment
Real number (ℝ)

Distinct	87955
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	445.03

Minimum	4.93
Maximum	1719.83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	4.93
5-th percentile	110.33
Q1	251.19
median	377.41
Q3	591.4
95-th percentile	986.47
Maximum	1719.83
Range	1714.9
Interquartile range (IQR)	340.21

Descriptive statistics

Standard deviation	267.16719
Coefficient of variation (CV)	0.60033523
Kurtosis	0.70471138
Mean	445.03
Median Absolute Deviation (MAD)	157.65
Skewness	1.0068004
Sum	7.6706528 × 10⁸
Variance	71378.307
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
301.15	3609	0.2%
332.1	3293	0.2%
327.34	3280	0.2%
361.38	2977	0.2%
451.73	2613	0.2%
602.3	2591	0.2%
329.72	2318	0.1%
318.79	2281	0.1%
312.86	2181	0.1%
392.81	2168	0.1%
Other values (87945)	1696315	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.93	1	< 0.1%
7.61	1	< 0.1%
14.01	1	< 0.1%
14.77	1	< 0.1%
19.4	1	< 0.1%
20.11	1	< 0.1%
23.26	1	< 0.1%
23.36	1	< 0.1%
25.81	1	< 0.1%
25.86	1	< 0.1%

Value	Count	Frequency (%)
1719.83	2	< 0.1%
1717.63	1	< 0.1%
1715.42	2	< 0.1%
1714.54	5	< 0.1%
1691.28	2	< 0.1%
1676.23	2	< 0.1%
1671.88	2	< 0.1%
1670.15	1	< 0.1%
1664.57	1	< 0.1%
1647.03	1	< 0.1%

int_rate
Real number (ℝ)

Distinct	395
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13186785

Minimum	0.0531
Maximum	0.3099
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0.0531
5-th percentile	0.0649
Q1	0.0949
median	0.1269
Q3	0.1601
95-th percentile	0.2235
Maximum	0.3099
Range	0.2568
Interquartile range (IQR)	0.0652

Descriptive statistics

Standard deviation	0.048386808
Coefficient of variation (CV)	0.36693406
Kurtosis	0.50430623
Mean	0.13186785
Median Absolute Deviation (MAD)	0.0325
Skewness	0.74298971
Sum	227290.86
Variance	0.0023412832
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1099	41298	2.4%
0.1199	40799	2.4%
0.0532	38914	2.3%
0.1399	34642	2.0%
0.1299	27678	1.6%
0.0789	27379	1.6%
0.0917	26922	1.6%
0.1699	26422	1.5%
0.1149	26326	1.5%
0.1561	24259	1.4%
Other values (385)	1408987	81.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0531	3294	0.2%
0.0532	38914	2.3%
0.0593	1809	0.1%
0.06	575	< 0.1%
0.0603	9250	0.5%
0.0607	2223	0.1%
0.0608	2937	0.2%
0.0611	3834	0.2%
0.0619	1314	0.1%
0.0624	7456	0.4%

Value	Count	Frequency (%)
0.3099	579	< 0.1%
0.3094	500	< 0.1%
0.3089	480	< 0.1%
0.3084	511	< 0.1%
0.3079	1049	0.1%
0.3075	714	< 0.1%
0.3074	314	< 0.1%
0.3065	638	< 0.1%
0.3049	348	< 0.1%
0.3017	775	< 0.1%

issue_d
Date

Distinct	96
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.3 MiB

Minimum	2012-08-01 00:00:00
Maximum	2020-09-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

last_fico_range_high
Real number (ℝ)

Distinct	72
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	678.56434

Minimum	0
Maximum	850
Zeros	178
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	519
Q1	624
median	694
Q3	739
95-th percentile	799
Maximum	850
Range	850
Interquartile range (IQR)	115

Descriptive statistics

Standard deviation	82.521206
Coefficient of variation (CV)	0.12161147
Kurtosis	-0.096922495
Mean	678.56434
Median Absolute Deviation (MAD)	50
Skewness	-0.55267549
Sum	1.1695911 × 10⁹
Variance	6809.7495
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
709	52576	3.1%
694	52004	3.0%
714	51829	3.0%
699	51696	3.0%
704	51590	3.0%
719	51275	3.0%
724	49743	2.9%
684	47392	2.7%
689	46898	2.7%
499	46074	2.7%
Other values (62)	1222549	70.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	178	< 0.1%
499	46074	2.7%
504	9844	0.6%
509	10503	0.6%
514	11848	0.7%
519	12131	0.7%
524	13700	0.8%
529	13441	0.8%
534	15212	0.9%
539	15271	0.9%

Value	Count	Frequency (%)
850	354	< 0.1%
844	847	< 0.1%
839	1591	0.1%
834	3157	0.2%
829	5231	0.3%
824	6753	0.4%
819	9793	0.6%
814	11379	0.7%
809	14106	0.8%
804	16641	1.0%

last_fico_range_low
Real number (ℝ)

ZEROS

Distinct	71
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	661.33278

Minimum	0
Maximum	845
Zeros	46252
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	515
Q1	620
median	690
Q3	735
95-th percentile	795
Maximum	845
Range	845
Interquartile range (IQR)	115

Descriptive statistics

Standard deviation	133.9242
Coefficient of variation (CV)	0.20250652
Kurtosis	13.21953
Mean	661.33278
Median Absolute Deviation (MAD)	50
Skewness	-3.1831876
Sum	1.1398904 × 10⁹
Variance	17935.69
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
705	52576	3.1%
690	52004	3.0%
710	51829	3.0%
695	51696	3.0%
700	51590	3.0%
715	51275	3.0%
720	49743	2.9%
680	47392	2.7%
685	46898	2.7%
0	46252	2.7%
Other values (61)	1222371	70.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	46252	2.7%
500	9844	0.6%
505	10503	0.6%
510	11848	0.7%
515	12131	0.7%
520	13700	0.8%
525	13441	0.8%
530	15212	0.9%
535	15271	0.9%
540	17076	1.0%

Value	Count	Frequency (%)
845	354	< 0.1%
840	847	< 0.1%
835	1591	0.1%
830	3157	0.2%
825	5231	0.3%
820	6753	0.4%
815	9793	0.6%
810	11379	0.7%
805	14106	0.8%
800	16641	1.0%

loan_amnt
Real number (ℝ)

Distinct	1561
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14760.653

Minimum	1000
Maximum	40000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	1000
5-th percentile	3200
Q1	8000
median	12300
Q3	20000
95-th percentile	35000
Maximum	40000
Range	39000
Interquartile range (IQR)	12000

Descriptive statistics

Standard deviation	8988.3744
Coefficient of variation (CV)	0.60894153
Kurtosis	-0.092056105
Mean	14760.653
Median Absolute Deviation (MAD)	5800
Skewness	0.7846035
Sum	2.5441845 × 10¹⁰
Variance	80790874
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	135539	7.9%
20000	94864	5.5%
15000	91914	5.3%
12000	91430	5.3%
35000	65192	3.8%
5000	64124	3.7%
8000	59372	3.4%
6000	56016	3.2%
16000	48573	2.8%
25000	46861	2.7%
Other values (1551)	969741	56.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	7535	0.4%
1025	29	< 0.1%
1050	43	< 0.1%
1075	20	< 0.1%
1100	216	< 0.1%
1125	36	< 0.1%
1150	33	< 0.1%
1175	14	< 0.1%
1200	2964	0.2%
1225	16	< 0.1%

Value	Count	Frequency (%)
40000	17924	1.0%
39975	10	< 0.1%
39950	5	< 0.1%
39925	6	< 0.1%
39900	15	< 0.1%
39875	5	< 0.1%
39850	4	< 0.1%
39825	10	< 0.1%
39800	9	< 0.1%
39775	9	< 0.1%

loan_status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

Fully Paid	1376874
Non-Performing	346752

Length

Max length	14
Median length	10
Mean length	10.804704
Min length	10

Characters and Unicode

Total characters	18623268
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fully Paid
2nd row	Fully Paid
3rd row	Fully Paid
4th row	Fully Paid
5th row	Fully Paid

Common Values

Value	Count	Frequency (%)
Fully Paid	1376874	79.9%
Non-Performing	346752	20.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fully	1376874	44.4%
paid	1376874	44.4%
non-performing	346752	11.2%

Most occurring characters

Value	Count	Frequency (%)
l	2753748	14.8%
P	1723626	9.3%
i	1723626	9.3%
F	1376874	7.4%
y	1376874	7.4%
	1376874	7.4%
a	1376874	7.4%
d	1376874	7.4%
u	1376874	7.4%
r	693504	3.7%
Other values (8)	3467520	18.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	18623268	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	2753748	14.8%
P	1723626	9.3%
i	1723626	9.3%
F	1376874	7.4%
y	1376874	7.4%
	1376874	7.4%
a	1376874	7.4%
d	1376874	7.4%
u	1376874	7.4%
r	693504	3.7%
Other values (8)	3467520	18.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	18623268	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	2753748	14.8%
P	1723626	9.3%
i	1723626	9.3%
F	1376874	7.4%
y	1376874	7.4%
	1376874	7.4%
a	1376874	7.4%
d	1376874	7.4%
u	1376874	7.4%
r	693504	3.7%
Other values (8)	3467520	18.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	18623268	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	2753748	14.8%
P	1723626	9.3%
i	1723626	9.3%
F	1376874	7.4%
y	1376874	7.4%
	1376874	7.4%
a	1376874	7.4%
d	1376874	7.4%
u	1376874	7.4%
r	693504	3.7%
Other values (8)	3467520	18.6%

purpose
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

debt_consolidation	992526
credit_card	390604
home_improvement	112479
other	101545
major_purchase	36821
Other values (9)	89651

Length

Max length	18
Median length	18
Mean length	14.882855
Min length	3

Characters and Unicode

Total characters	25652475
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	debt_consolidation
2nd row	home_improvement
3rd row	debt_consolidation
4th row	debt_consolidation
5th row	debt_consolidation

Common Values

Value	Count	Frequency (%)
debt_consolidation	992526	57.6%
credit_card	390604	22.7%
home_improvement	112479	6.5%
other	101545	5.9%
major_purchase	36821	2.1%
medical	20170	1.2%
car	17095	1.0%
small_business	16957	1.0%
vacation	11825	0.7%
moving	11594	0.7%
Other values (4)	12010	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
debt_consolidation	992526	57.6%
credit_card	390604	22.7%
home_improvement	112479	6.5%
other	101545	5.9%
major_purchase	36821	2.1%
medical	20170	1.2%
car	17095	1.0%
small_business	16957	1.0%
vacation	11825	0.7%
moving	11594	0.7%
Other values (4)	12010	0.7%

Most occurring characters

Value	Count	Frequency (%)
o	3374406	13.2%
d	2788164	10.9%
t	2601507	10.1%
i	2549549	9.9%
n	2140893	8.3%
e	1912306	7.5%
c	1859647	7.2%
_	1550446	6.0%
a	1535707	6.0%
s	1107258	4.3%
Other values (12)	4232592	16.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	25652475	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	3374406	13.2%
d	2788164	10.9%
t	2601507	10.1%
i	2549549	9.9%
n	2140893	8.3%
e	1912306	7.5%
c	1859647	7.2%
_	1550446	6.0%
a	1535707	6.0%
s	1107258	4.3%
Other values (12)	4232592	16.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	25652475	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	3374406	13.2%
d	2788164	10.9%
t	2601507	10.1%
i	2549549	9.9%
n	2140893	8.3%
e	1912306	7.5%
c	1859647	7.2%
_	1550446	6.0%
a	1535707	6.0%
s	1107258	4.3%
Other values (12)	4232592	16.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	25652475	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	3374406	13.2%
d	2788164	10.9%
t	2601507	10.1%
i	2549549	9.9%
n	2140893	8.3%
e	1912306	7.5%
c	1859647	7.2%
_	1550446	6.0%
a	1535707	6.0%
s	1107258	4.3%
Other values (12)	4232592	16.5%

revol_bal
Real number (ℝ)

Distinct	92466
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16487.053

Minimum	0
Maximum	2904836
Zeros	6602
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	1701
Q1	5972
median	11219
Q3	19980
95-th percentile	44335
Maximum	2904836
Range	2904836
Interquartile range (IQR)	14008

Descriptive statistics

Standard deviation	22643.897
Coefficient of variation (CV)	1.3734351
Kurtosis	589.10068
Mean	16487.053
Median Absolute Deviation (MAD)	6237
Skewness	12.648816
Sum	2.8417513 × 10¹⁰
Variance	5.1274607 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6602	0.4%
8	170	< 0.1%
6312	134	< 0.1%
5453	131	< 0.1%
2	128	< 0.1%
5891	123	< 0.1%
5232	123	< 0.1%
5849	123	< 0.1%
6118	122	< 0.1%
5570	122	< 0.1%
Other values (92456)	1715848	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6602	0.4%
1	91	< 0.1%
2	128	< 0.1%
3	116	< 0.1%
4	112	< 0.1%
5	107	< 0.1%
6	113	< 0.1%
7	94	< 0.1%
8	170	< 0.1%
9	112	< 0.1%

Value	Count	Frequency (%)
2904836	1	< 0.1%
2568995	1	< 0.1%
2560703	1	< 0.1%
1746716	1	< 0.1%
1743266	1	< 0.1%
1696796	1	< 0.1%
1470945	1	< 0.1%
1392002	1	< 0.1%
1298783	1	< 0.1%
1190046	1	< 0.1%

revol_util
Real number (ℝ)

Distinct	1302
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.50486359

Minimum	0
Maximum	3.666
Zeros	8029
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.096
Q1	0.318
median	0.505
Q3	0.694
95-th percentile	0.91
Maximum	3.666
Range	3.666
Interquartile range (IQR)	0.376

Descriptive statistics

Standard deviation	0.24626981
Coefficient of variation (CV)	0.48779475
Kurtosis	-0.80767585
Mean	0.50486359
Median Absolute Deviation (MAD)	0.188
Skewness	-0.011133263
Sum	870196.02
Variance	0.060648819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8029	0.5%
0.48	3358	0.2%
0.57	3346	0.2%
0.58	3314	0.2%
0.59	3313	0.2%
0.53	3298	0.2%
0.61	3277	0.2%
0.55	3246	0.2%
0.54	3228	0.2%
0.46	3216	0.2%
Other values (1292)	1686001	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8029	0.5%
0.001	1329	0.1%
0.002	1089	0.1%
0.003	1000	0.1%
0.004	880	0.1%
0.005	833	< 0.1%
0.006	763	< 0.1%
0.007	740	< 0.1%
0.008	727	< 0.1%
0.009	705	< 0.1%

Value	Count	Frequency (%)
3.666	1	< 0.1%
1.93	1	< 0.1%
1.846	1	< 0.1%
1.828	1	< 0.1%
1.803	1	< 0.1%
1.777	1	< 0.1%
1.72	1	< 0.1%
1.669	1	< 0.1%
1.658	1	< 0.1%
1.62	1	< 0.1%

sub_grade
Categorical

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

C1	109536
B4	107459
B5	107087
B3	100642
C2	100128
Other values (30)	1198774

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3447252
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B2
2nd row	B2
3rd row	B2
4th row	A3
5th row	B4

Common Values

Value	Count	Frequency (%)
C1	109536	6.4%
B4	107459	6.2%
B5	107087	6.2%
B3	100642	5.8%
C2	100128	5.8%
C3	97262	5.6%
C4	96530	5.6%
B2	95260	5.5%
B1	94588	5.5%
C5	88488	5.1%
Other values (25)	726646	42.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c1	109536	6.4%
b4	107459	6.2%
b5	107087	6.2%
b3	100642	5.8%
c2	100128	5.8%
c3	97262	5.6%
c4	96530	5.6%
b2	95260	5.5%
b1	94588	5.5%
c5	88488	5.1%
Other values (25)	726646	42.2%

Most occurring characters

Value	Count	Frequency (%)
B	505036	14.7%
C	491944	14.3%
1	372403	10.8%
4	343145	10.0%
2	339603	9.9%
5	338462	9.8%
3	330013	9.6%
A	318334	9.2%
D	257183	7.5%
E	107703	3.1%
Other values (2)	43426	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3447252	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	505036	14.7%
C	491944	14.3%
1	372403	10.8%
4	343145	10.0%
2	339603	9.9%
5	338462	9.8%
3	330013	9.6%
A	318334	9.2%
D	257183	7.5%
E	107703	3.1%
Other values (2)	43426	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3447252	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	505036	14.7%
C	491944	14.3%
1	372403	10.8%
4	343145	10.0%
2	339603	9.9%
5	338462	9.8%
3	330013	9.6%
A	318334	9.2%
D	257183	7.5%
E	107703	3.1%
Other values (2)	43426	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3447252	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	505036	14.7%
C	491944	14.3%
1	372403	10.8%
4	343145	10.0%
2	339603	9.9%
5	338462	9.8%
3	330013	9.6%
A	318334	9.2%
D	257183	7.5%
E	107703	3.1%
Other values (2)	43426	1.3%

term
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

36 months	1284233
60 months	439393

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	17236260
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	36 months
2nd row	36 months
3rd row	36 months
4th row	36 months
5th row	36 months

Common Values

Value	Count	Frequency (%)
36 months	1284233	74.5%
60 months	439393	25.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
months	1723626	50.0%
36	1284233	37.3%
60	439393	12.7%

Most occurring characters

Value	Count	Frequency (%)
	3447252	20.0%
6	1723626	10.0%
m	1723626	10.0%
o	1723626	10.0%
n	1723626	10.0%
t	1723626	10.0%
h	1723626	10.0%
s	1723626	10.0%
3	1284233	7.5%
0	439393	2.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17236260	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	3447252	20.0%
6	1723626	10.0%
m	1723626	10.0%
o	1723626	10.0%
n	1723626	10.0%
t	1723626	10.0%
h	1723626	10.0%
s	1723626	10.0%
3	1284233	7.5%
0	439393	2.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17236260	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	3447252	20.0%
6	1723626	10.0%
m	1723626	10.0%
o	1723626	10.0%
n	1723626	10.0%
t	1723626	10.0%
h	1723626	10.0%
s	1723626	10.0%
3	1284233	7.5%
0	439393	2.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17236260	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	3447252	20.0%
6	1723626	10.0%
m	1723626	10.0%
o	1723626	10.0%
n	1723626	10.0%
t	1723626	10.0%
h	1723626	10.0%
s	1723626	10.0%
3	1284233	7.5%
0	439393	2.5%

verification_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

Source Verified	688888
Not Verified	539198
Verified	495540

Length

Max length	15
Median length	12
Mean length	12.049027
Min length	8

Characters and Unicode

Total characters	20768016
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Verified
2nd row	Source Verified
3rd row	Verified
4th row	Not Verified
5th row	Not Verified

Common Values

Value	Count	Frequency (%)
Source Verified	688888	40.0%
Not Verified	539198	31.3%
Verified	495540	28.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
verified	1723626	58.4%
source	688888	23.3%
not	539198	18.3%

Most occurring characters

Value	Count	Frequency (%)
e	4136140	19.9%
i	3447252	16.6%
r	2412514	11.6%
V	1723626	8.3%
f	1723626	8.3%
d	1723626	8.3%
o	1228086	5.9%
	1228086	5.9%
S	688888	3.3%
u	688888	3.3%
Other values (3)	1767284	8.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20768016	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	4136140	19.9%
i	3447252	16.6%
r	2412514	11.6%
V	1723626	8.3%
f	1723626	8.3%
d	1723626	8.3%
o	1228086	5.9%
	1228086	5.9%
S	688888	3.3%
u	688888	3.3%
Other values (3)	1767284	8.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20768016	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	4136140	19.9%
i	3447252	16.6%
r	2412514	11.6%
V	1723626	8.3%
f	1723626	8.3%
d	1723626	8.3%
o	1228086	5.9%
	1228086	5.9%
S	688888	3.3%
u	688888	3.3%
Other values (3)	1767284	8.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20768016	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	4136140	19.9%
i	3447252	16.6%
r	2412514	11.6%
V	1723626	8.3%
f	1723626	8.3%
d	1723626	8.3%
o	1228086	5.9%
	1228086	5.9%
S	688888	3.3%
u	688888	3.3%
Other values (3)	1767284	8.5%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	addr_state	annual_inc	application_type	avg_cur_bal	bc_util	delinq_2yrs	dti	emp_length	emp_title	fico_range_high	fico_range_low	grade	home_ownership	inq_last_6mths	installment	int_rate	issue_d	last_fico_range_high	last_fico_range_low	loan_amnt	loan_status	purpose	revol_bal	revol_util	sub_grade	term	verification_status
42536	NC	60000.0	Individual	476.0	15.9	0.0	4.62	4 years	Project Manager	724.0	720.0	B	RENT	1.0	392.81	0.1099	2013-12-01	569.0	565.0	12000.0	Fully Paid	debt_consolidation	7137.0	0.240	B2	36 months	Not Verified
42537	TX	39600.0	Individual	1379.0	16.1	0.0	2.49	2 years	Surgical Technician	759.0	755.0	B	MORTGAGE	2.0	157.13	0.1099	2013-12-01	534.0	530.0	4800.0	Fully Paid	home_improvement	4136.0	0.161	B2	36 months	Source Verified
42538	MI	55000.0	Individual	9570.0	53.9	0.0	22.87	10+ years	Team Leadern Customer Ops & Systems	734.0	730.0	B	OWN	0.0	885.46	0.1099	2013-12-01	834.0	830.0	27050.0	Fully Paid	debt_consolidation	36638.0	0.612	B2	36 months	Verified
42539	TX	96500.0	Individual	11783.0	83.5	0.0	12.61	3 years	Systems Engineer	709.0	705.0	A	MORTGAGE	0.0	373.94	0.0762	2013-12-01	809.0	805.0	12000.0	Fully Paid	debt_consolidation	13248.0	0.557	A3	36 months	Not Verified
42540	NC	88000.0	Individual	2945.0	87.7	1.0	10.02	4 years	Assistant Director - Human Resources	674.0	670.0	B	RENT	0.0	470.71	0.1285	2013-12-01	569.0	565.0	14000.0	Fully Paid	debt_consolidation	3686.0	0.819	B4	36 months	Not Verified
42541	CT	105000.0	Individual	26765.0	25.0	0.0	14.05	10+ years	MANAGER INFORMATION DELIVERY	764.0	760.0	A	MORTGAGE	1.0	368.45	0.0662	2013-12-01	779.0	775.0	12000.0	Fully Paid	debt_consolidation	13168.0	0.216	A2	36 months	Not Verified
42542	FL	63000.0	Individual	38927.0	79.1	0.0	16.51	2 years	aircraft maintenance engineer	674.0	670.0	A	MORTGAGE	0.0	476.30	0.0890	2013-12-01	749.0	745.0	15000.0	Fully Paid	debt_consolidation	11431.0	0.742	A5	36 months	Not Verified
42543	CA	28000.0	Individual	1440.0	96.0	0.0	8.40	3 years	Special Order Fulfillment Clerk	664.0	660.0	C	RENT	0.0	266.34	0.1624	2013-12-01	634.0	630.0	7550.0	Fully Paid	debt_consolidation	5759.0	0.720	C5	36 months	Not Verified
42544	CA	325000.0	Individual	53306.0	67.1	0.0	18.55	5 years	Area Sales Manager	749.0	745.0	A	MORTGAGE	1.0	872.52	0.0762	2013-12-01	789.0	785.0	28000.0	Fully Paid	debt_consolidation	29581.0	0.546	A3	36 months	Source Verified
42545	CO	130000.0	Individual	36362.0	93.0	0.0	13.03	10+ years	LTC	719.0	715.0	B	MORTGAGE	1.0	398.52	0.1199	2013-12-01	714.0	710.0	12000.0	Fully Paid	debt_consolidation	10805.0	0.670	B3	36 months	Source Verified

	addr_state	annual_inc	application_type	avg_cur_bal	bc_util	delinq_2yrs	dti	emp_length	emp_title	fico_range_high	fico_range_low	grade	home_ownership	inq_last_6mths	installment	int_rate	issue_d	last_fico_range_high	last_fico_range_low	loan_amnt	loan_status	purpose	revol_bal	revol_util	sub_grade	term	verification_status
2856439	CA	60000.0	Individual	6463.0	71.2	0.0	28.34	10+ years	Housekeeping	769.0	765.0	B	RENT	0.0	576.09	0.0944	2017-06-01	829.0	825.0	18000.0	Fully Paid	debt_consolidation	15316.0	0.417	B1	36 months	Not Verified
2856440	NJ	200000.0	Individual	71965.0	78.8	2.0	24.44	10+ years	OWNER	694.0	690.0	B	MORTGAGE	0.0	980.89	0.1091	2017-06-01	734.0	730.0	30000.0	Fully Paid	debt_consolidation	39843.0	0.715	B4	36 months	Verified
2856442	CO	89000.0	Individual	27498.0	76.2	0.0	18.88	10+ years	Superintendent	744.0	740.0	A	MORTGAGE	0.0	869.05	0.0735	2017-06-01	814.0	810.0	28000.0	Fully Paid	debt_consolidation	28422.0	0.534	A4	36 months	Not Verified
2856443	KS	180000.0	Individual	31465.0	94.8	0.0	16.54	10+ years	Partner	709.0	705.0	B	MORTGAGE	0.0	251.68	0.0944	2017-06-01	739.0	735.0	12000.0	Fully Paid	debt_consolidation	28105.0	0.672	B1	60 months	Source Verified
2856444	CA	125000.0	Individual	4763.0	66.0	1.0	8.70	10+ years	associate advisor	689.0	685.0	A	RENT	3.0	670.41	0.0735	2017-06-01	699.0	695.0	21600.0	Fully Paid	credit_card	28598.0	0.620	A4	36 months	Verified
2856447	FL	110000.0	Individual	25116.0	87.3	1.0	21.11	2 years	tech data author	689.0	685.0	C	MORTGAGE	2.0	1094.12	0.1359	2017-06-01	684.0	680.0	32200.0	Fully Paid	debt_consolidation	31457.0	0.914	C2	36 months	Verified
2856449	CA	240000.0	Individual	62430.0	59.8	0.0	12.19	2 years	Vice President Quality	729.0	725.0	B	MORTGAGE	1.0	1128.21	0.0993	2017-06-01	729.0	725.0	35000.0	Fully Paid	credit_card	44329.0	0.577	B2	36 months	Source Verified
2856450	PA	100000.0	Individual	58595.0	62.5	0.0	7.84	10+ years	Regional General Manager	694.0	690.0	A	MORTGAGE	0.0	156.62	0.0797	2017-06-01	669.0	665.0	5000.0	Fully Paid	major_purchase	11750.0	0.527	A5	36 months	Verified
2856451	OH	40000.0	Individual	2360.0	33.4	0.0	25.86	10+ years	Clerk	779.0	775.0	B	RENT	0.0	340.88	0.1042	2017-06-01	804.0	800.0	10500.0	Fully Paid	credit_card	13285.0	0.319	B3	36 months	Source Verified
2856452	CA	32000.0	Individual	2573.0	0.0	0.0	27.57	NaN	NaN	684.0	680.0	B	OWN	0.0	193.41	0.0993	2017-06-01	539.0	535.0	6000.0	Non-Performing	debt_consolidation	2855.0	0.127	B2	36 months	Verified

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories